CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9302.TXT

Text File | 1993-12-28 | 80KB | 1,704 lines

=========================================================================
Date:         Tue, 16 Feb 1993 12:22:26 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      columns in reports?

OK, I love the Report Wizard, but how do I get a report that prints on
only half the page to print in two columns?  It looks like the report
would fit quite well but I don't see how to do that.  Any ideas?  I
hate wasting all that paper....

=========================================================================
Date:         Tue, 16 Feb 1993 12:29:10 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Oops...

Sorry...I just found it under the Setup button in Preview...It's not a
good day here.  :)

=========================================================================
Date:         Tue, 16 Feb 1993 10:07:22 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE: columns in reports?

Use SETUP when displaying the report (not in design mode). Select MORE
button, and specify 2 or more columns per page, then format the layout
of those colmns (vertical or horizontal or ...). Then you'll get two columns.
----------
|From: "NATHAN BRINDLE"  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Subject: columns in reports?
|Date: Tuesday, February 16, 1993 12:22PM
|
|OK, I love the Report Wizard, but how do I get a report that prints on
|only half the page to print in two columns?  It looks like the report
|would fit quite well but I don't see how to do that.  Any ideas?  I
|hate wasting all that paper....
|
|-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
|Nathan C. Brindle, Student Activities Office
|Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
|Indiana University-Purdue University at Indianapolis
|Internet:    [e-mail] or [e-mail]
|Compu$erve:  [e-mail]
|------------------------------------------------------------------------------
|
|
=========================================================================
Date:         Tue, 16 Feb 1993 16:04:00 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      What's up?

Hi there,

isn't there anything to discuss? I am looking for some applications written
in Access because I want to see the ability of that program. Is there an
ftp-site where I can download some applications?

What about the rumours that there are some bugs in Access?

I programmed a lot in dBase and Clipper (up to dbase IV 1.1 and Clipper 5.0)
and my first impression of Access is that live is much easier now. But: Did
anyone test some megs of datas? What about the speed?

Let's discuss or this list will die very soon.

Greetings

Detlef Schwenke               E-Mail: [e-mail] or
Philipps-University Marburg           [e-mail]
Universitaetsstr. 25           Phone: [phone]
W-3550 Marburg                   Fax: [phone]
Germany
=========================================================================
Date:         Tue, 16 Feb 1993 16:04:03 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Re: What's up?
In-Reply-To:  Message of Tue,
              16 Feb 1993 16:04:00 PST from <Schwenke@MAILGATE.W
              IWI.UNI-MARBURG.DE>

Thanks for your concern about the list, but it's less than a week old,
and I don't intend to let it die anytime soon...:)

I am currently running three major, unrelated (to each other) databases
in Access, but since I'm still learning what it's capable of, I don't
have anything of major importance to report.  I programmed extensively
in dBase IV 1.5 until I got thorougly sick of it.  Access popped up at
a very good time for me.  I love the ease of creating queries and forms
and reports.  Things I didn't have the energy to code in dBase have become
a few minutes' worth of work in Access.  It seems to me that this is a
product with great potential.

I'll let others deal with reported bugs--I have not noticed any (yet).

Nathan Brindle
Listowner, ACCESS-L@INDYCMS

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
Indiana University-Purdue University at Indianapolis
Internet:    [e-mail] or [e-mail]
Compu$erve:  [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 16 Feb 1993 11:45:00 HST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Michael E. Macmillan" <[e-mail]>
Subject:      Re: What's up?

>I'll let others deal with reported bugs--I have not noticed any (yet).

Bugs there are, but how important they are probably depends on what
you do.  There is an official list in the MSACCESS forum on CompuServe
and probably on the Microsoft electronic bulletin board system.

Michael E. Macmillan
(macmillm@ewc)
=========================================================================
Date:         Tue, 16 Feb 1993 17:23:04 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         J BOWDEN <[e-mail]>
Subject:      Re: What's up?

what is the current cost of ACCESS? I tried to get my parents to
get it for me for christmas - but they couldn't find a copy to buy.

what is it running for now?

jim
[e-mail]
=========================================================================
Date:         Tue, 16 Feb 1993 19:42:14 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         George Waller <[e-mail]>
Subject:      Making a PC map

Can anyone figure out how to do the following using ACCESS? I want
to keep an inventory of PCs with the usual fields for type, serial#,
warranty expiration date. That is simple enough, but I would also like
to map their location. For example:

:-------------------------------------------------------------:
:  PC01                                                       :
:  Warr: 3-7-93                      PC03                     :
:  ID#: Z44832                       Warr: 2-22-87            :
:                     PC02           ID#: G33492              :
:                     Warr: 3-7-93                            :
:                     ID#: Z89832                             :
:-------------------------------------------------------------:

There would be other info of a textual nature such as
department name, lines for walls. Any ideas out there?

------------------------------------------------------------------------
George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
University of Connecticut,  Storrs CT 06269-1005         203-486-5260
Internet: [e-mail]    Bitnet: [e-mail]
------------------------------------------------------------------------
=========================================================================
Date:         Wed, 17 Feb 1993 08:44:16 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Resent-From: NATHAN BRINDLE <NBRINDLE@INDYCMS>
Comments:     Originally-From: Revised List Processor (1.7e)
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      ACCESS-L: error report from MSU

The following message was sent to me as an error.  I have reposted it for
those who will be interested.  The problem was that the mail software on
the user's machine copies the header of the forwarded message as well as
the body of the message <into the body> of the new message.  This will
always cause an error and the message will not be distributed.  If your
mail software formats forwarded messages this way, you may not want to
use forwards with LISTSERV.   --Nathan Brindle, listowner

>>From: "David.Martell" <SFS01@MSU>
>>Subject: Re: What's up?

I was selling for $99 until early January as special offer retail.  I believe
the normal retail is $259.  I have not seen an educational discounted price
yet.  I will be waiting for that price before I purchase.  I have signed up to
this list to see some interaction from those of you that actually now using
it.

***Forwarded Message Ends***

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Indiana University-Purdue University at Indianapolis
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 17 Feb 1993 09:13:48 -0600
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Bill R. Holman" <[e-mail]>
Subject:      Separating data and application

Could someone tell me how to port tables from one application space
to another.  I am developing new forms, queries, and reports  on my
computer which is independant of the others.  Meanwhile that which I
have already completed is already in use, meaning that they have been
doing tremendous amounts of data entry.  When I try and copy the
newest revision of forms, queries, and reports to disk and then to
their computers it also forces me to copy the data as it existed on
my machine, losing all revisions that they had made since my last
change.

Up until now I have had to cut and paste tables from their db to the
new one I install but this seems like a work-around.  There has to be
a better way...I hope all this made sense...any help would be
appreciated.

Bill Holman
[e-mail]
Brigham Young University
=========================================================================
Date:         Wed, 17 Feb 1993 09:43:00 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      AW: Making a PC map

>Can anyone figure out how to do the following using ACCESS? I want
>to keep an inventory of PCs with the usual fields for type, serial#,
>warranty expiration date.

We are planning to do just the same thing.

>to map their location. For example:
>
>:-------------------------------------------------------------:
>:  PC01                                                       :
>:  Warr: 3-7-93                      PC03                     :
>:  ID#: Z44832                       Warr: 2-22-87            :
>:                     PC02           ID#: G33492              :
>:                     Warr: 3-7-93                            :
>:                     ID#: Z89832                             :
>:-------------------------------------------------------------:

I think that it is possible to archive PCX-pictures too. Why don't you make
a PCX and put it into your application. Not the best solution, I know but
maybe a way to try out.

>------------------------------------------------------------------------
>George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
>University of Connecticut,  Storrs CT 06269-1005         203-486-5260
>Internet: [e-mail]    Bitnet: [e-mail]
>------------------------------------------------------------------------

Another thing: I have seen some guys from Microsoft subscribed to this list.
Can we hope that our hints on improving MS-Access will be forwarded to the
developers? When will the Runtime-Module be released (and when will it be
released in Germany)?

Greetings

Detlef Schwenke               E-Mail: [e-mail] or
Philipps-University Marburg           [e-mail]
Universitaetsstr. 25           Phone: [phone]
W-3550 Marburg                   Fax: [phone]
Germany
=========================================================================
Date:         Wed, 17 Feb 1993 19:30:00 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Clare Love <[e-mail]>
Subject:      re. Making a PC map

George Waller asks:

>Can anyone figure out how to do the following using ACCESS? I want
>to keep an inventory of PCs with the usual fields for type, serial#,
>warranty expiration date. That is simple enough, but I would also like
>to map their location. For example:
>
>:-------------------------------------------------------------:
>:  PC01                                                       :
>:  Warr: 3-7-93                      PC03                     :
>:  ID#: Z44832                       Warr: 2-22-87            :
>:                     PC02           ID#: G33492              :
>:                     Warr: 3-7-93                            :
>:                     ID#: Z89832                             :
>:-------------------------------------------------------------:
>
>There would be other info of a textual nature such as
>department name, lines for walls. Any ideas out there?
>
>------------------------------------------------------------------------
>George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
>University of Connecticut,  Storrs CT 06269-1005         203-486-5260
>Internet: [e-mail]    Bitnet: [e-mail]
>------------------------------------------------------------------------
>
I have little experience with ACCESS, but it appears that ACCESS itself is not
going to provide the graphic capabilities you require.  It looks as though you
need to link ACCESS up with some tool such as AutoCAD to do things right.
Perhaps someone more knowledgable than I can clue us in on how to go about
this.  I too have applications where I need to combine database, and drawing
capabilities... not just a link to a bitmap graphic snapshot.

Can someone explain the proper relationship between ACCESS, and Visual BASIC?
Perhaps the solution lies there.

Clare Love
[phone]
[e-mail]
=========================================================================
Date:         Wed, 17 Feb 1993 14:39:35 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         George Waller <[e-mail]>
Subject:      Re: AW: Making a PC map
In-Reply-To:  Message of Wed,
              17 Feb 1993 09:43:00 PST from <Schwenke@MAILGATE.W
              IWI.UNI-MARBURG.DE>

On Wed, 17 Feb 1993 09:43:00 PST <[e-mail]> said:
>>Can anyone figure out how to do the following using ACCESS? I want
>>to keep an inventory of PCs with the usual fields for type, serial#,
>>warranty expiration date.
>
>We are planning to do just the same thing.
>
>
>I think that it is possible to archive PCX-pictures too. Why don't you make
>a PCX and put it into your application. Not the best solution, I know but
>maybe a way to try out.
>Detlef Schwenke               E-Mail: [e-mail] or

Thanks Detlef, I did start trying out the following:
Create a form with a subform. The form has a Paintbrush file showing
a map of the department and other fields about the department. The
subform will have the info about the PCs in a tabular format. On the
"map" there will be an abbreviation for the PC which will point to
the details in the subform. Not exactly the way I wanted to do it, but
close enough. Thanks, George.

------------------------------------------------------------------------
George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
University of Connecticut,  Storrs CT 06269-1005         203-486-5260
Internet: [e-mail]    Bitnet: [e-mail]
------------------------------------------------------------------------
=========================================================================
Date:         Wed, 17 Feb 1993 15:40:18 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Ray Porrata" <[e-mail]>
Subject:      RE: AW: Making a PC map

Is there a way that this location be placed on a grid like mapping(ie:
setting up a grid of buttons with dialogs attached to them)?

Also take a look at the PSet Method.  I'll leave it from there for you
to play with.

Good Luck

Ray  :-)
=========================================================================
Date:         Wed, 17 Feb 1993 15:35:25 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     <Parser> E: RFC822 "local part" (username) containing a blank was
              encountered. These usernames are not presently supported.
From:         Undetermined origin c/o Postmaster <[e-mail]>
Subject:      RE: AW: Making a PC map

Is there a way that this location be placed on a grid like map?  Also
take a look at the PSet Method.  I'll leave it from there for you to play with.

Good Luck

Ray  :-)
----------
From:  <netmail![e-mail]>
To: Multiple recipients of list ACCESS-L
<[e-mail]>
Subject: AW: Making a PC map
Date: Wednesday, February 17, 1993 9:43AM

>Can anyone figure out how to do the following using ACCESS? I want
>to keep an inventory of PCs with the usual fields for type, serial#,
>warranty expiration date.

We are planning to do just the same thing.

>to map their location. For example:
>
>:-------------------------------------------------------------:
>:  PC01                                                       :
>:  Warr: 3-7-93                      PC03                     :
>:  ID#: Z44832                       Warr: 2-22-87            :
>:                     PC02           ID#: G33492              :
>:                     Warr: 3-7-93                            :
>:                     ID#: Z89832                             :
>:-------------------------------------------------------------:

I think that it is possible to archive PCX-pictures too. Why don't you make
a PCX and put it into your application. Not the best solution, I know but
maybe a way to try out.

>------------------------------------------------------------------------
>George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
>University of Connecticut,  Storrs CT 06269-1005         203-486-5260
>Internet: [e-mail]    Bitnet: [e-mail]
>------------------------------------------------------------------------

Another thing: I have seen some guys from Microsoft subscribed to this list.
Can we hope that our hints on improving MS-Access will be forwarded to the
developers? When will the Runtime-Module be released (and when will it be
released in Germany)?

Greetings

Detlef Schwenke               E-Mail: [e-mail] or
Philipps-University Marburg           [e-mail]
Universitaetsstr. 25           Phone: [phone]
W-3550 Marburg                   Fax: [phone]
Germany
=========================================================================
Date:         Wed, 17 Feb 1993 20:42:51 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Chris Allison <[e-mail]>
Subject:      How do I subset a data field?

   I have an account code field in my database which I need to subset.  I can
not figure out a way to tell ACCESS to split one field into (in this case) 5
new fields.  Anyone know how to solve this?

                  -----  Chris Allison
  Miami University
  137 Hoyt Hall             Bitnet  : [e-mail]
  Oxford OH. 45056          Usenet  : [e-mail]
=========================================================================
Date:         Wed, 17 Feb 1993 20:58:00 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Jeffrey M. Gipson" <[e-mail]>
Subject:      Re: How do I subset a data field?

>   I have an account code field in my database which I need to subset.  I can
>not figure out a way to tell ACCESS to split one field into (in this case) 5
>new fields.  Anyone know how to solve this?
>                  -----  Chris Allison
>  Miami University
>  137 Hoyt Hall             Bitnet  : [e-mail]
>  Oxford OH. 45056          Usenet  : [e-mail]

        I had a similar problem with a text field that contained social
security numbers that I wanted to divide into three separate fields. What I
did was to create the new fields and then designed an update query to parse
the original field and update the relavent information in the new ones.

        -J. M. Gipson

----------------------------------------------------------------------------
        J. M. Gipson                                    [e-mail]
        Knox College
        Box 418
        Galesburg, IL 61401
=========================================================================
Date:         Thu, 18 Feb 1993 09:33:00 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      AW: Separating data and application

>Could someone tell me how to port tables from one application space
>to another.  I am developing new forms, queries, and reports  on my
>computer which is independant of the others.  Meanwhile that which I
>have already completed is already in use, meaning that they have been
>doing tremendous amounts of data entry.  When I try and copy the
>newest revision of forms, queries, and reports to disk and then to
>their computers it also forces me to copy the data as it existed on
>my machine, losing all revisions that they had made since my last
>change.
Hi Bill,
do I understand it right that you do not really to port the tables but that
you want to update the forms, queries and reports on some computers? If it's
that you want to do you can do it simply with cut and paste too. Just open
the mdb-file with the new form or querie on the computer you want to port
your form/query to. Then copy your form/query into the clipboard and close
the file. Open the file you want to port it to and activate the form or
query-view (button). Insert the form/query. If you don't have created new
objects or manipulated the table-structure, it should work. I tried it and
it worked well.

>Up until now I have had to cut and paste tables from their db to the
>new one I install but this seems like a work-around.  There has to be
>a better way...I hope all this made sense...any help would be
>appreciated.

I aggree that it can be useful (Hi, Microsoft) to implement a feature to
export/import a form/query seperately.

Detlef Schwenke               E-Mail: [e-mail] or
Philipps-University Marburg           [e-mail]
Universitaetsstr. 25           Phone: [phone]
W-3550 Marburg                   Fax: [phone]
Germany
=========================================================================
Date:         Fri, 19 Feb 1993 10:53:24 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      leaving command button out of tab order

I know I know how to do this, but I can't figure it out.  How do I keep
a command button from getting the focus, or keeping it out of the tab
order?  I don't want a user to accidentally hit return on this button
and thereby run the related macro--I want the user to have to push the button
with the mouse or hit the Alt-key assigned.

Thanks for help...:)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Feb 1993 16:26:28 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Pekka Koskinen CIMO <[e-mail]>
Subject:      Sorting tables

I've been wondering if there is an easy way to sort the records to a
RANDOM order? (just don't ask why I want to do it...)

Does anyone know how to do it (without writing a long application)?

Thanks in advance!

Pekka

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
Pekka Koskinen           !
CIMO                     !     Life is transitory.  Rather like
tel [phone]  !   a sparrow flying through a mead hall.
fax [phone]  !  (translation of an Old English Proverb)
=========================================================================
Date:         Mon, 22 Feb 1993 13:54:43 -0600
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         MARK TURPIN <[e-mail]>
Subject:      RE: Sorting tables

Try This....
        1. Create a random table
                primary key
                random number

        2. Link the random table to the table you want to sort in random order
           by primay keys one-to-one relationship

        3. sort random table by random number
           the output will now be in random order.
=========================================================================
Date:         Tue, 23 Feb 1993 09:41:08 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Pekka Koskinen CIMO <[e-mail]>
Subject:      RE: Sorting tables to random order

On 22 Feb 1993 13:54:43 -0600, MARK TURPIN wrote:

>Try This....
>        1. Create a random table
>                primary key
>                random number
>
>        2. Link the random table to the table you want to sort in random order
>           by primay keys one-to-one relationship
>
>        3. sort random table by random number
>           the output will now be in random order.

Makes sense to me, I will try it this way! Thanks a lot!

Pekka

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
Pekka Koskinen           !
CIMO                     !     Life is transitory.  Rather like
tel [phone]  !   a sparrow flying through a mead hall.
fax [phone]  !  (translation of an Old English Proverb)
=========================================================================
Date:         Tue, 23 Feb 1993 16:06:13 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Query query

I'm running a select query based on a table that has fields containing
Firstname, Middlename, and Lastname.  What I want to do is create an
expression field that would give me Firstname Middlename Lastname for
the purpose of creating a list that looks relatively nice.  The problem
is that not all of the records in the table have a value for Middlename,
and the select query just returns a blank.  This is not the first time
I've had this problem, but it's become sort of serious and I haven't
been able to find the answer in the documentation (either that or I'm
too dense to see it).

Any help would be appreciated.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 23 Feb 1993 15:42:04 CST
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "R. D. McClary" <[e-mail]>
Subject:      RE: Query query

In Message Tue, 23 Feb 1993 16:06:13 EST,
  "NATHAN BRINDLE" <[e-mail]> writes:

>I'm running a select query based on a table that has fields containing
>Firstname, Middlename, and Lastname.  What I want to do is create an
>expression field that would give me Firstname Middlename Lastname for
>the purpose of creating a list that looks relatively nice.  The problem
>is that not all of the records in the table have a value for Middlename,
>and the select query just returns a blank.  This is not the first time
>I've had this problem, but it's become sort of serious and I haven't
>been able to find the answer in the documentation (either that or I'm
>too dense to see it).
>
>Any help would be appreciated.
>
>-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
>Nathan C. Brindle, Student Activities Office
>Indiana University Purdue University Indianapolis
>Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
>List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
>Internet:    [e-mail] or [e-mail]
>------------------------------------------------------------------------------


     I agree, the documentation can be a bit vague!  Appendix C should have
been bound separately.  I think what you want would be on page 653.  You
search on a field - any field - but show only the calculated field.  The "&"
concatenates the field.  There might be a way to compensate for the null in
the middlename field, but this should give you something.  (There will be,
unfortunately, an extra large space between firstname and lastname.)

============================================================================

     HELP!!!

Is there any simple way to get Access to capitalize either the first letter
in a text field or the first letter of each word?  I can do that in a number
of other databases, but Access seems to limit me to just ">" or "<".
Thanks!
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
               /|              []
            ` o.O '            []   [e-mail]
            =(___)=            []   R. D. McClary
               U               []   Department of Plant Pathology
          ACK!THPTPHH!         []   University of Illinois, Urbana-Champaign
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
=========================================================================
Date:         Tue, 23 Feb 1993 17:03:13 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      RE: Query query
In-Reply-To:  Message of Tue,
              23 Feb 1993 15:42:04 CST from <[e-mail]. EDU>

Thank you thank you thank you!

FirstName&" "&MiddleName&" "&LastName worked where FirstName+" "+MiddleName+
" "+LastName didn't.  I think I see why.  The plus acts as an AND operator
and the & just concatenates strings.  I can live with the extra space...

Regards,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 23 Feb 1993 14:07:26 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Chuck Catlett" <[e-mail]>
Subject:      Re: Query query
In-Reply-To:  Your message of Tue,
              23 Feb 93 16:06:13 -0500. <[e-mail]>

>> Date:    Tue, 23 Feb 1993 16:06:13 EST
>> To:      Multiple recipients of list ACCESS-L <[e-mail]>
>> From:    "NATHAN BRINDLE" <[e-mail]>
>> Subject: Query query
>>
>> I'm running a select query based on a table that has fields containing
>> Firstname, Middlename, and Lastname.  What I want to do is create an
>> expression field that would give me Firstname Middlename Lastname for
>> the purpose of creating a list that looks relatively nice.  The problem
>> is that not all of the records in the table have a value for Middlename,
>> and the select query just returns a blank.  This is not the first time
>> I've had this problem, but it's become sort of serious and I haven't
>> been able to find the answer in the documentation (either that or I'm
>> too dense to see it).
>>
>> Any help would be appreciated.
>>
>> -----------------------------------------------------BITNET:  NBRINDLE@INDYCM
   S
>> Nathan C. Brindle, Student Activities Office
>> Indiana University Purdue University Indianapolis
>> Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
>> List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
>> Internet:    [e-mail] or [e-mail]
>> -----------------------------------------------------------------------------
   -


  See pages 484 and 485, Combining Text Values, in the User's Guide.
  It describes exactly what you want, I believe.  (OK so I wasted
  an hour looking for that thing that I knew I'd seen somewhere in
  that damn documentation.  Just don't tell anyone, ok?)
=========================================================================
Date:         Tue, 23 Feb 1993 22:30:38 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Msr. Brad Choate" <[e-mail]>
Subject:      RE: Query query

>FirstName&" "&MiddleName&" "&LastName worked where FirstName+" "+MiddleName+
>" "+LastName didn't.  I think I see why.  The plus acts as an AND operator
>and the & just concatenates strings.  I can live with the extra space...

You don't *have* to live with the extra space, though!  There may be a
better way, but what _I_ would do is this:

   RTrim$(FirstName&" "&MiddleName)&" "&LastName

This would avoid the double space if the MiddleName field is blank.  If
there is a chance that FirstName could be blank, then the best
expression (although not pretty) would be this:

   LTrim$(RTrim$(FirstName&" "&MiddleName)&" "&LastName)

There.  If there's a better way, feel free to let me know.  I'm *always*
open to ways of making life just a little bit easier! :)

-Brad
--
Disclaimer: I claim dis claim.

Brad S. Choate
[e-mail]
=========================================================================
Date:         Tue, 23 Feb 1993 22:36:12 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         NSF SF Bay research projects <[e-mail]>

Hello all:

I, as everybody else, couldn't resist the $99 purchase
price, so I bought a copy of Access.  Now I want to find out
really how useful this software is.

I have built databases with SQL commands (well, er,
actually QUEL, but that's another story) and want to use
some of my queries in Access.  Some of these are pages-long
scripts of SQL commands; so, my question is this:  Can I
import these documents into Access and execute them?  I
know you can view and/or edit the SQL rendition of an
Access query, but what I want is a little more ambitious, I
want to import whole sequences of SQL commands from
pre-existing files -- can this be done?

I'd like to know your thoughts on this matter.  Please post
to the mail server or write to me directly

Thank you, Howard Foster ([e-mail])
=========================================================================
Date:         Wed, 24 Feb 1993 08:36:10 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         The Hole in the Wall Gang <[e-mail]>
Subject:      ECO '93...and MS-ACCESS

Hello/Bonjour;

I have just recieved a Registration card from ECO '93 (East Cost
Oracle) User group announcing a Meeting 4-6, 1993 at the Philadelphia
Hilton and Towers.  Unfortunately, I will be unable to attend, and
am hopeful that someone on this list will be attending.  Three of
the sessions have a "Just Added" flag against them; Microsoft Access
ODBC Connection to Oracle, The New Client/Server API from Oracle New
Technologies, and Client/Server Implementing Oracle Applications
Network.  Of course, these are the three I'm most curious about.  If
someone going could post an abstract of one or more of the sessions to
this list or to my address I would appreciate recieving the information.
          Thank's in advance...
                                  Frank  (Gid'day Marcia)



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      "The views expressed here are my own, not AECL Research Company."

Frank C. Brown                                   Voice: [phone] 6195
Business and Information Systems                   Fax: [phone]
Atomic Energy of Canada Ltd, Research Company
Chalk River Laboratories                      Bitnet: [e-mail]
Chalk River, Ontario, Canada                Internet: [e-mail]
K0J 1J0

~~~~~~~~~~~~~~~~~~~~~~~~~~The Hole in the Wall Gang~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date:         Wed, 24 Feb 1993 07:45:24 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE:

In my experience of SQL products, Access type SQL is a non-standard
version of SQL and most likely not at all compatable with QUEL brand of
SQL statements. On top of this there is no facility in Access to do
what you want to do apart from writing a module to do it for you.
----------
|From: NSF SF Bay research projects  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Date: Tuesday, February 23, 1993 10:36PM
|
|Hello all:
|
|I, as everybody else, couldn't resist the $99 purchase
|price, so I bought a copy of Access.  Now I want to find out
|really how useful this software is.
|
|I have built databases with SQL commands (well, er,
|actually QUEL, but that's another story) and want to use
|some of my queries in Access.  Some of these are pages-long
|scripts of SQL commands; so, my question is this:  Can I
|import these documents into Access and execute them?  I
|know you can view and/or edit the SQL rendition of an
|Access query, but what I want is a little more ambitious, I
|want to import whole sequences of SQL commands from
|pre-existing files -- can this be done?
|
|I'd like to know your thoughts on this matter.  Please post
|to the mail server or write to me directly
|
|Thank you, Howard Foster ([e-mail])
|
|
=========================================================================
Date:         Wed, 24 Feb 1993 11:15:54 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Resent-From: NATHAN BRINDLE <NBRINDLE@INDYCMS>
Comments:     Originally-From: Myles Leitch <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>

This was sent directly to me, but I suspect it is really aimed at the list,
so I am reposting it.

I would like to participate in the ACCESS discussion group. We are using
ACCESS in a linguistics project here at UBC. A first question that I have
for anyone is the following: in a Table is there any way to specify a
particular font for a particular field (column). It seems to be the case
that in Table view, only one font per table is allowed. This is kind of
messy since we are working with multiple fonts in many tables including
phonetics characters and potentially non-roman scripts as well. Of course
this is not a problem for FORMS or REPORTS. It is a problem for Tables and
for Queries which use the Table type format. Anybody got any ideas on how
to get round this?

Myles Leitch

*FORWARDED MESSAGE ENDS*

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 24 Feb 1993 11:35:06 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         KENTON HENSLEY 617-496-2131 <[e-mail]>
Subject:      Capitalizing first letters of words in a control

I'm afraid your choice of formatting symbols does limit you to > and < - all
characters upper or all lower case.  You will have to code a function in
access basic, passing it the contents of the control on a form, and using
the string functions InStr() and UCase() to help you do what you want.  Not
as easy as one would like.  Not like paradox which has a rich set of
formatting symbols/functions.

Kenton Hensley
Harvard Law Library
=========================================================================
Date:         Wed, 24 Feb 1993 15:47:05 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Jonathan Lavigne" <[e-mail]>
Subject:      Exporting ASCII text from Access

I was fairly impressed at how easily Access imports lengthy text
fields.  Unfortunately, I'm also rather dismayed at how difficult
it is to get the same data out again in a form I can use with other
programs.

I have a table with several fields including one that contains help
screens formatted only with carriage returns and one that contains
the names of the screens.  I'd like to be able to have Access save
each screen in a separate file that has the same name as the screen
name.  It seems to me that, in dBase, I could have written a little
program to do this sort of thing.  I haven't yet found any way that
promises to let me do it with Access, though I spent several hours
leafing through the documentation.

At the very least, I'd like to be able to get even a single
comma-delimited file that includes only the screens and screen
names.  Even that seems impossible.  Access will export the entire
table, but it doesn't seem to let me choose which fields to
include. It's all or nothing, as far as I can see.

I got the OUTPUTAS.DLL file from CompuServe that is supposed to make
it possible to save a report as ASCII text.  Unfortunately, when I
tried to make a report that included the field containing the screen
text, I got an unhelpful message telling me the field didn't exist.
This even though I dragged the field name onto the report form from
the field list.  (Is this a known bug, or do I need to do something
to a memo field before I can use it in a report?) Even if I could
define a proper report, it seems the DLL will write out only as much
data from a field as I leave room for on the report form.  Since the
screen fields vary in length, this isn't very encouraging.

What I ended up doing is exporting the table from Access as a dBase
IV file. I then imported the dBase file into FileMaker Pro and used
that program to produce the comma-delimited file I needed.  Figuring
out how to do it took about five minutes in FileMaker Pro.  This
solution works, but it's hardly satisfactory.  Access seems severely
limited in the choices it gives you for exporting data. Does anyone
know of any better ways to get a comma-delimited file out of Access
that doesn't include all the fields in a table and that doesn't
depend on writing a report form?

Jonathan Lavigne       [e-mail]
Research Libraries Group/Stanford University

To:  ACCESS-L@INDYCMS
=========================================================================
Date:         Wed, 24 Feb 1993 19:13:18 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Re: Exporting ASCII text from Access
In-Reply-To:  Message of Wed, 24 Feb 1993 15:47:05 PST from <BL.JPL@RLG>

Just as something you might want to try...how about creating a query with
the field data you want, writing that query to a table (I saw an option
in one of the pull-downs, but I'm nowhere near my documentation), and then
exporting the new table?

Sorry for the limited specifics, but as I say, I'm nowhere near the
manuals.

HTH,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 24 Feb 1993 16:27:20 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE: Exporting ASCII text from Access

Try making the field on the report expandable and contactable
(properties: grow and shrink set to yes). The width of your field will
still remain the same but the height (number of lines) will grow with
the contents.You will also need to format this field to insert your
quotes (chr$(34) ) and commas (",") in a combined string... like using:
         =chr$(34) & [field1] & chr$(34) & "," & chr$(34) & [field2] & chr$(34)

Then print your report to an ascii file via the generic/text printer
driver hooked to the FILE: device (simple Windows functionality here).

I've done this and it works just fine on large non-memo character
fields, should work for memo fields as well.
Mark
----------
|From: "Jonathan Lavigne"  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Subject: Exporting ASCII text from Access
|Date: Wednesday, February 24, 1993 3:47PM
|
|I was fairly impressed at how easily Access imports lengthy text
|fields.  Unfortunately, I'm also rather dismayed at how difficult
|it is to get the same data out again in a form I can use with other
|programs.
|
|I have a table with several fields including one that contains help
|screens formatted only with carriage returns and one that contains
|the names of the screens.  I'd like to be able to have Access save
|each screen in a separate file that has the same name as the screen
|name.  It seems to me that, in dBase, I could have written a little
|program to do this sort of thing.  I haven't yet found any way that
|promises to let me do it with Access, though I spent several hours
|leafing through the documentation.
|
|At the very least, I'd like to be able to get even a single
|comma-delimited file that includes only the screens and screen
|names.  Even that seems impossible.  Access will export the entire
|table, but it doesn't seem to let me choose which fields to
|include. It's all or nothing, as far as I can see.
|
|I got the OUTPUTAS.DLL file from CompuServe that is supposed to make
|it possible to save a report as ASCII text.  Unfortunately, when I
|tried to make a report that included the field containing the screen
|text, I got an unhelpful message telling me the field didn't exist.
|This even though I dragged the field name onto the report form from
|the field list.  (Is this a known bug, or do I need to do something
|to a memo field before I can use it in a report?) Even if I could
|define a proper report, it seems the DLL will write out only as much
|data from a field as I leave room for on the report form.  Since the
|screen fields vary in length, this isn't very encouraging.
|
|What I ended up doing is exporting the table from Access as a dBase
|IV file. I then imported the dBase file into FileMaker Pro and used
|that program to produce the comma-delimited file I needed.  Figuring
|out how to do it took about five minutes in FileMaker Pro.  This
|solution works, but it's hardly satisfactory.  Access seems severely
|limited in the choices it gives you for exporting data. Does anyone
|know of any better ways to get a comma-delimited file out of Access
|that doesn't include all the fields in a table and that doesn't
|depend on writing a report form?
|
|Jonathan Lavigne       [e-mail]
|Research Libraries Group/Stanford University
|
|To:  ACCESS-L@INDYCMS
|
|
=========================================================================
Date:         Thu, 25 Feb 1993 10:47:28 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      comma-delimited

Was someone having trouble yesterday exporting to comma-delimited files?
I just did one for kicks and giggles and never saw anything so easy in
my life.  Choose Export and Delimited (Text), set a couple of options
if need be, and away you go.

Sorry if my memory is going...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 25 Feb 1993 08:12:52 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE: comma-delimited

This  solution works fine for exporting entire tables, but not queries
or selected columns of a given table.
----------
|From: "NATHAN BRINDLE"  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Subject: comma-delimited
|Date: Thursday, February 25, 1993 10:47AM
|
|Was someone having trouble yesterday exporting to comma-delimited files?
|I just did one for kicks and giggles and never saw anything so easy in
|my life.  Choose Export and Delimited (Text), set a couple of options
|if need be, and away you go.
|
|Sorry if my memory is going...
|
|-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
|Nathan C. Brindle, Student Activities Office
|Indiana University Purdue University Indianapolis
|Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
|List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
|Internet:    [e-mail] or [e-mail]
|------------------------------------------------------------------------------
|
|
=========================================================================
Date:         Thu, 25 Feb 1993 11:48:42 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      RE: comma-delimited
In-Reply-To:  Message of Thu,
              25 Feb 1993 08:12:52 PDT from <[e-mail] >

Then you run a MAKE TABLE query, create a temporary table that way for
use in exporting, and export.  One extra step.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 25 Feb 1993 17:07:36 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         KENTON HENSLEY 617-496-2131 <[e-mail]>
Subject:      Re: Exporting ASCII text from Access

Nathan Brindles idea is dead on.  Create a query with the fields you
want in it.  From the menu choose Query/Make Table. and you have a new
table with just the right fields that you can export.

Kenton Hensley
Harvard Law Library
=========================================================================
Date:         Thu, 25 Feb 1993 12:13:55 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Ascii reports

Well, I've had a chance to try both methods for outputing ascii reports, and
the generic printer/print to file option is definitely superior.  It takes a
little work to set up (I needed to find a version of tty.srv and tty.hlp--
they're on the last of the Windows 3.1 distribution disks) but it does all I
expect it to do.

In my case, I'm using the report to generate input to troff (which, among other
things, allows me to print variable sized records in my phone book
application).  I've constructed an ABF to operate on each record, making
invisible any controls which contain no data.  In my test case, I needed to do
some editing of the form to ensure a minimum spacing between fields, and to
avoid a line concatenation problem I was having between records, and outputing
the pages seemed a little slow on my 16MHz 386 machine, but I ended up with a
file of 83968 bytes.

However, having just installed outputas.dll, I tried outputing the same form
using it.  The print speed was noticably slower, the resulting file was 288768
bytes in size, and examination of the file revealed that outputas.dll bypasses
the report events mechanism: every control was printed in every record, which
probably accounts for some of the size increase and speed loss.

So, if you don't have outputas.dll already, I'd recommend just installing the
generic printer (which uses files you should already have), and does IMHO an
all around better job of producing ascii reports.
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

Hawaii has always been a very pivotal role in the Pacific.  It is in the
Pacific.  It is part of the United States that is an island that is right
there.
--Dan Quayle, speaking with reporters in Hawaii, May 1989
________________________________________________________________________________
=========================================================================
Date:         Thu, 25 Feb 1993 19:48:28 +0100
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Detlef Kuepper <[e-mail]>
Subject:      RE:
In-Reply-To:  <[e-mail]>

"Mark Barnet (Business Enter. Syst. Tech)" writes:
 >
 > In my experience of SQL products, Access type SQL is a non-standard
 > version of SQL and most likely not at all compatable with QUEL brand of
 > SQL statements. On top of this there is no facility in Access to do
 > what you want to do apart from writing a module to do it for you.

I think SQL is standardized by ANSI. Does anybody know to what degree
ACCESS supports this standard?


Detlef Kuepper   [e-mail]
=========================================================================
Date:         Fri, 26 Feb 1993 11:41:01 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re:
In-Reply-To:  Your message of "Thu, 25 Feb 93 19:48:28 +0100."

>> I think SQL is standardized by ANSI. Does anybody know to what degree
>> ACCESS supports this standard?
>>
>> Detlef Kuepper   [e-mail]

I thought the book went into pretty good detail on that. I bought the ANSI
spec and there is an awful lot of "vendor-dependent" wording in the spec
itself. So you can easily have an SQL implementation that is ANSI compliant
but not portable.

Besides, standards are great because there's so many to choose from!

Joe Prevo   [e-mail]
=========================================================================
Date:         Fri, 26 Feb 1993 12:59:33 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         George Waller <[e-mail]>
Subject:      Column widths

This is no doubt right in the documentation, but could someone
please tell me:

1. How to save column widths in a query.

2. When using formwizard and specifying tabular form, default spaces
   are left between the fields. I would like no spaces between the fields
   so the form looks more like a data entry sheet.
Thanks!
------------------------------------------------------------------------
George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
University of Connecticut,  Storrs CT 06269-1005         203-486-5260
Internet: [e-mail]    Bitnet: [e-mail]
------------------------------------------------------------------------
=========================================================================
Date:         Fri, 26 Feb 1993 13:19:18 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Resent-From: NATHAN BRINDLE <NBRINDLE@INDYCMS>
Comments:     Originally-From: George Waller <[e-mail]>
Comments:     Warning -- original Sender: tag was ACCESS-L@INDYCMS
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Column widths

>This is no doubt right in the documentation, but could someone
>please tell me:
>
>1. How to save column widths in a query.

      This appears to be a function of what you've set them to in the table(s)
      you're basing the query on.  There isn't a Save Layout option in the
      File menu in Query view.

>2. When using formwizard and specifying tabular form, default spaces
>   are left between the fields. I would like no spaces between the fields
>   so the form looks more like a data entry sheet.

     I suspect that the answer to this is to shift to Design View and change
     things to fit what you want.  I don't recall any way to change the FW
     defaults, but (as always) I could be wrong....

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 26 Feb 1993 15:15:56 CST
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Mike Miller <[e-mail]>
Subject:      Nested queries

Anyone know how to make this happen in Access...

SELECT X FROM A
  WHERE X NOT IN
    ( SELECT X FROM B);

mj
--
Michaeljon Miller                             [e-mail]
Apertus Technologies                   612-828-0161 / 612-860-2181
7275 Flying Cloud Drive                 Eden Prairie, MN     55344
=========================================================================
Date:         Fri, 26 Feb 1993 14:59:22 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         NSF SF Bay research projects <[e-mail]>

>From: Mike Miller <[e-mail]>
>Subject:      Nested queries
>Anyone know how to make this happen in Access...
>
>SELECT X FROM A
>  WHERE X NOT IN
>    ( SELECT X FROM B);
>
>mj

The following is inelegent but is easy to understand
....

In QUEL this is:

        retrieve into X (
                A.all
                )
        delete X where X.key = B.key

So in SQL this is something like (excuse my syntax)

        SELECT X FROM A
        DELETE  FROM A
                WHERE A.key IN
                (SELECT B.key FROM B)


-Howard ([e-mail])

PS Hey!  How about an asnswer to my SQL question --
about importing long SQL queries into ACCESS.  Is
it possible?
=========================================================================
Date:         Fri, 26 Feb 1993 15:10:04 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Tab move sequence in Form.
In-Reply-To:  <[e-mail]>; from "George Waller" at Feb
              26, 93 12:59 pm

Greetings!
        How do you assign the sequence of control field movement in which
the cursor is going to go when a TAB key is hit. It seems to be depending
 on the sequence you inserted the field while designing the form...any help?
 and ..thanks in advance...

Fred Chin
internet: [e-mail]
bitnet: [e-mail]
=========================================================================
Date:         Fri, 26 Feb 1993 18:36:55 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>
Subject:      Nested Queries

>>From: Mike Miller <[e-mail]>
>>Subject:      Nested queries
>>Anyone know how to make this happen in Access...
>>
>>SELECT X FROM A
>>  WHERE X NOT IN
>>    ( SELECT X FROM B);
>>
>>mj
>
>The following is inelegent but is easy to understand
>....
>
>In QUEL this is:
>
>        retrieve into X (
>                A.all
>                )
>        delete X where X.key = B.key
>
>So in SQL this is something like (excuse my syntax)
>
>        SELECT X FROM A
>        DELETE  FROM A
>                WHERE A.key IN
>                (SELECT B.key FROM B)
>
>
>-Howard ([e-mail])
>
>PS Hey!  How about an asnswer to my SQL question --
>about importing long SQL queries into ACCESS.  Is
>it possible?

I found subselects (or nested queries or whatever) impossible to use in
Access.  Even hacking the view SQL text window caused errors.

Howard, you can try importing SQL queries through pasting into the view SQL text
window or try making them query objects in access basic I think.  I haven't
messed with this (or access) recently so am not sure.

gr.
--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail] (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)
=========================================================================
Date:         Fri, 26 Feb 1993 18:47:21 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Re: Tab move sequence in Form.
In-Reply-To:  Message of Fri, 26 Feb 1993 15:10:04 PST from <[e-mail]>

Yes, go to the Edit menu while in Form Design and choose the last option,
Tab Order.  That will bring up a dialog box that allows you to switch
things around.

HOWEVER...one thing it <doesn't> do is let you leave something OUT of the
Tab order completely, such as a command button.  Does anyone have any
ideas on how to accomplish that?  I'm at a loss.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 26 Feb 1993 16:32:46 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     <Parser> E: RFC822 "local part" (username) containing a blank was
              encountered. These usernames are not presently supported.
From:         Undetermined origin c/o Postmaster <[e-mail]>
Subject:      Re: Tab move sequence in Form.
In-Reply-To:  Your message of Fri,
              26 Feb 93 18:47:21 -0500. <[e-mail]>

[e-mail] writes:
|Yes, go to the Edit menu while in Form Design and choose the last option,
|Tab Order.  That will bring up a dialog box that allows you to switch
|things around.
|
|HOWEVER...one thing it <doesn't> do is let you leave something OUT of the
|Tab order completely, such as a command button.  Does anyone have any
|ideas on how to accomplish that?  I'm at a loss.

I just did a little be of exploring that today, but I don't think you're going
to like the answer.  There appears to be two properties that remove a control
from the tab order, but both have side effects: Visible does it, but makes the
control invisible.  Select also does it, but makes the control unselectable.
So far I haven't found any other way.

So, are other people coming to the conclusion that MS Access is a hodged
together POS like I am?
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

I had never regarded writing software as a legitimate profession.
It was like writing poetry--admirable, but you couldn't make a
living at it.
--S. Jerrold Kaplan, one of the founders of Teknowledge Inc.
________________________________________________________________________________
=========================================================================
Date:         Fri, 26 Feb 1993 16:34:31 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Tab move sequence in Form.
In-Reply-To:  Your message of Fri,
              26 Feb 93 18:47:21 -0500. <[e-mail]>

[e-mail] writes:
|Yes, go to the Edit menu while in Form Design and choose the last option,
|Tab Order.  That will bring up a dialog box that allows you to switch
|things around.
|
|HOWEVER...one thing it <doesn't> do is let you leave something OUT of the
|Tab order completely, such as a command button.  Does anyone have any
|ideas on how to accomplish that?  I'm at a loss.

I just did a little be of exploring that today, but I don't think you're going
to like the answer.  There appears to be two properties that remove a control
from the tab order, but both have side effects: Visible does it, but makes the
control invisible.  Select also does it, but makes the control unselectable.
So far I haven't found any other way.

So, are other people coming to the conclusion that MS Access is a hodged
together POS like I am?
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

I got a postcard from my friend George with a satellite picture of
the entire earth.  On the back he wrote, "Wish you were here."
--Steve Wright
________________________________________________________________________________
=========================================================================
Date:         Fri, 26 Feb 1993 17:04:22 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re: Tab move sequence in Form.

In reply to message of Fri, 26 Feb 1993 18:47:21 EST from Nathan Brindle

>HOWEVER...one thing it <doesn't> do is let you leave something OUT of the
>Tab order completely, such as a command button.  Does anyone have any
>ideas on how to accomplish that?  I'm at a loss.

In Visual Basic, this is done by setting the TabStop property of a control to
False.  Finding this lacking in Access Basic, and noting that tab order is
done in a dialog box where this is not an option (rather than with a TabIndex
property), it looks like it is a point of flexibility that MS left out of
Access, perhaps to keep it simpler for the non-programmer.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Fri, 26 Feb 1993 17:17:07 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re: Tab move sequence in Form.

In reply to message of Fri, 26 Feb 1993 18:47:21 EST from Nathan Brindle

>>HOWEVER...one thing it <doesn't> do is let you leave something OUT of the
>>Tab order completely, such as a command button.  Does anyone have any
>>ideas on how to accomplish that?  I'm at a loss.

>In Visual Basic, this is done by setting the TabStop property of a control to
>False.  Finding this lacking in Access Basic, and noting that tab order is
>done in a dialog box where this is not an option (rather than with a TabIndex
>property), it looks like it is a point of flexibility that MS left out of
>Access, perhaps to keep it simpler for the non-programmer.

In correction of my prior message, try setting the Enabled property to No for
the control in question.  This prevents it from having Focus, and should
therefore keep it out of the Tab sequence.  It is still visible, but grayed.
Of course, this does mean it is disabled, but that is essentially what you
mean if you are preventing the user from tabbing to it.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Fri, 26 Feb 1993 20:29:07 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Re: Tab move sequence in Form.
In-Reply-To:  Message of Fri,
              26 Feb 1993 17:17:07 PST from <[e-mail] .EDU>

Unfortunately disabling it is not going to suit the purpose.  I want
to have a button that operates that isn't in the tab order.  I guess
I'll have to wait for the next version or try something that someone
else suggested in private mail, that is, put the button in the header
or footer of the form.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------